How to: Remove tables or queries from a query.
Solution:
Go to the Query Design view, select the table or query to remove, and use the 'Delete' command on the 'Edit' menu.
1) If the Database window is not active, activate the Database window.
2) Go to the Query Design view.
3) Select the table or query to remove by clicking in its field list box.
4) Select the 'Edit' menu and select 'Delete'. (The selected table or query is removed from the Query Design window.)
5) Select the 'File' menu and select 'Save' to save the design changes.
6) (Optional) Select the 'File' menu and select 'Close' to close the Query Design view.
